To rebuild a table
Caution! Never run an older version of DB Maintenance against a newer database.
1. Have all users log out of iMIS.
2. Schedule downtime for rebuilding tables containing large amounts of data.
3. Back up all tables that you plan to rebuild.
4. From the Start menu, select DB Maintenance Utility in the iMIS program group.
5. Select the table to be rebuilt.
6. Click Rebuild Table.
To rebuild a customized table
If you have added custom objects (Foreign Key constraints, triggers, indexes) to iMIS tables, you must remove the customizations and then add them back.
1. Record all custom database objects that you have added to your iMIS tables, because you must manually recreate them.
2. Manually remove your objects; for example, drop all foreign key constraints on the table (both to and from the table, so you must also check other referencing tables and drop the relevant foreign keys there as well).
3. Restart DB Maintenance, select the tables, and click Rebuild Table.
4. Manually recreate all custom foreign key constraints that you recorded.